/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80019
 Source Host           : 127.0.0.1:3306
 Source Schema         : my_crm

 Target Server Type    : MySQL
 Target Server Version : 80019
 File Encoding         : 65001

 Date: 15/06/2021 17:23:05
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '电子邮箱',
  `username` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户名',
  `nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '昵称',
  `password` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '密码',
  `salt` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '密码盐',
  `avatar` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '头像',
  `loginfailure` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '失败次数',
  `token` varchar(59) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'Token标识',
  `token_expiry_time` datetime NOT NULL DEFAULT '0000-01-01 00:00:00' COMMENT 'Token失效时间',
  `status` tinyint unsigned NOT NULL DEFAULT '1' COMMENT '状态:0=禁用,1=正常',
  `login_time` datetime NOT NULL DEFAULT '0000-01-01 00:00:00' COMMENT '登录时间',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `username` (`username`) USING BTREE,
  UNIQUE KEY `admin_email_uindex` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='管理员表';

-- ----------------------------
-- Records of admin
-- ----------------------------
BEGIN;
INSERT INTO `admin` VALUES (1, 'admin@admin.com', 'admin', '我是超级管理员', '5f1d7a84db00d2fce00b31a7fc73224f', '123456', '/avatar2.jpg', 0, '8321261c59e9b6e2c58d33d190cff3ce', '2021-06-22 17:15:38', 1, '2021-06-15 17:15:38', '2020-08-12 17:39:41', '2021-06-15 17:15:38');
INSERT INTO `admin` VALUES (22, 'admin1@admin.com', 'admin1', '我是管理员', '7c6fdcc5a506d3f449431efb579b7f9c', '3de9d4', '', 0, '1ec80d26aaffc7d73248eaaae83f3a62', '2021-06-22 17:10:59', 1, '2021-06-15 17:10:59', '2021-06-15 17:10:45', '2021-06-15 17:14:31');
COMMIT;

-- ----------------------------
-- Table structure for admin_operation_log
-- ----------------------------
DROP TABLE IF EXISTS `admin_operation_log`;
CREATE TABLE `admin_operation_log` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `admin_id` int unsigned NOT NULL DEFAULT '0' COMMENT '管理员ID',
  `username` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '管理员名字',
  `url` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '操作页面',
  `title` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '日志标题',
  `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '内容',
  `ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'IP',
  `useragent` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'User-Agent',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `name` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8015 DEFAULT CHARSET=utf8 COMMENT='管理员操作日志表';

-- ----------------------------
-- Records of admin_operation_log
-- ----------------------------
BEGIN;
INSERT INTO `admin_operation_log` VALUES (8001, 1, 'admin', 'http://localhost:8000/admin/role', 'admin.role.add', '{\"method\":\"admin.role.add\",\"pid\":\"1\",\"name\":\"一级管理员\",\"status\":\"1\",\"resource_id\":\"2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23\"}', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.101 Safari/537.36', '2021-06-15 17:08:47');
INSERT INTO `admin_operation_log` VALUES (8002, 1, 'admin', 'http://localhost:8000/admin/role', 'admin.role.add', '{\"method\":\"admin.role.add\",\"pid\":\"4154\",\"name\":\"二级管理员\",\"status\":\"1\",\"resource_id\":\"2,3,4,5,6,7,8,9,10,11,12,13,14\"}', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.101 Safari/537.36', '2021-06-15 17:09:03');
INSERT INTO `admin_operation_log` VALUES (8003, 1, 'admin', 'http://localhost:8000/admin/role', 'admin.role.add', '{\"method\":\"admin.role.add\",\"pid\":\"4155\",\"name\":\"三级管理员\",\"status\":\"1\",\"resource_id\":\"2,3,4,5,6,7,8\"}', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.101 Safari/537.36', '2021-06-15 17:09:25');
INSERT INTO `admin_operation_log` VALUES (8004, 1, 'admin', 'http://localhost:8000/admin/role', 'admin.role.add', '{\"method\":\"admin.role.add\",\"pid\":\"4156\",\"name\":\"四级管理员\",\"status\":\"1\",\"resource_id\":\"2,3,4,5\"}', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.101 Safari/537.36', '2021-06-15 17:09:49');
INSERT INTO `admin_operation_log` VALUES (8005, 1, 'admin', 'http://localhost:8000/admin/admin', 'admin.admin.add', '{\"method\":\"admin.admin.add\",\"role_id\":[\"4154\"],\"nickname\":\"我是管理员\",\"username\":\"admin\",\"email\":\"admin@admin.com\",\"password\":\"123456\",\"status\":\"1\"}', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.101 Safari/537.36', '2021-06-15 17:10:27');
INSERT INTO `admin_operation_log` VALUES (8006, 1, 'admin', 'http://localhost:8000/admin/admin', 'admin.admin.add', '{\"method\":\"admin.admin.add\",\"role_id\":[\"4154\"],\"nickname\":\"我是管理员\",\"username\":\"admin\",\"email\":\"admin@admin.com\",\"password\":\"123456\",\"status\":\"1\"}', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.101 Safari/537.36', '2021-06-15 17:10:32');
INSERT INTO `admin_operation_log` VALUES (8007, 1, 'admin', 'http://localhost:8000/admin/admin', 'admin.admin.add', '{\"method\":\"admin.admin.add\",\"role_id\":[\"4154\"],\"nickname\":\"我是管理员\",\"username\":\"admin1\",\"email\":\"admin1@admin.com\",\"password\":\"123456\",\"status\":\"1\"}', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.101 Safari/537.36', '2021-06-15 17:10:45');
INSERT INTO `admin_operation_log` VALUES (8008, 1, 'admin', 'http://localhost:8000/admin/admin', 'auth.logout', '{\"method\":\"auth.logout\",\"0\":\"1-72b0d54c02cbcc3b462dc76e91d07fd0\"}', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.101 Safari/537.36', '2021-06-15 17:10:52');
INSERT INTO `admin_operation_log` VALUES (8009, 22, 'admin1', 'http://localhost:8000/auth/login', 'auth.login', '{\"method\":\"auth.login\",\"account\":\"admin1\",\"password\":\"123456\"}', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.101 Safari/537.36', '2021-06-15 17:10:59');
INSERT INTO `admin_operation_log` VALUES (8010, 22, 'admin1', 'http://localhost:8000/admin/admin', 'auth.logout', '{\"method\":\"auth.logout\",\"0\":\"22-1ec80d26aaffc7d73248eaaae83f3a62\"}', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.101 Safari/537.36', '2021-06-15 17:13:20');
INSERT INTO `admin_operation_log` VALUES (8011, 1, 'admin', 'http://localhost:8000/auth/login', 'auth.login', '{\"method\":\"auth.login\",\"account\":\"admin\",\"password\":\"123456\"}', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.101 Safari/537.36', '2021-06-15 17:13:25');
INSERT INTO `admin_operation_log` VALUES (8012, 1, 'admin', 'http://localhost:8000/admin/admin', 'admin.admin.edit', '{\"method\":\"admin.admin.edit\",\"role_id\":[\"4154\",\"4155\",\"4156\",\"4157\"],\"nickname\":\"我是管理员\",\"username\":\"admin1\",\"email\":\"admin1@admin.com\",\"status\":\"1\",\"id\":\"22\"}', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.101 Safari/537.36', '2021-06-15 17:14:31');
INSERT INTO `admin_operation_log` VALUES (8013, 1, 'admin', 'http://localhost:8000/admin/log', 'auth.logout', '{\"method\":\"auth.logout\",\"0\":\"1-a550bfb9978c4b219e9be66f8e73b7d9\"}', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.101 Safari/537.36', '2021-06-15 17:15:31');
INSERT INTO `admin_operation_log` VALUES (8014, 1, 'admin', 'http://localhost:8000/auth/login', 'auth.login', '{\"method\":\"auth.login\",\"account\":\"admin\",\"password\":\"123456\"}', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.101 Safari/537.36', '2021-06-15 17:15:38');
COMMIT;

-- ----------------------------
-- Table structure for admin_resource
-- ----------------------------
DROP TABLE IF EXISTS `admin_resource`;
CREATE TABLE `admin_resource` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `pid` int unsigned NOT NULL DEFAULT '0' COMMENT '父ID',
  `type` tinyint unsigned NOT NULL DEFAULT '1' COMMENT '资源类型:1=菜单,2=节点',
  `path` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'URI(前端)',
  `resource` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '资源(绑定的后端接口)',
  `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名称',
  `icon` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '图标',
  `remark` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '备注',
  `badge` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '标记',
  `weigh` int unsigned NOT NULL DEFAULT '0' COMMENT '权重',
  `status` tinyint unsigned NOT NULL DEFAULT '1' COMMENT '状态:0=隐藏,1=显示',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uri` (`path`) USING BTREE,
  KEY `pid` (`pid`) USING BTREE,
  KEY `weigh` (`weigh`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='资源表';

-- ----------------------------
-- Records of admin_resource
-- ----------------------------
BEGIN;
INSERT INTO `admin_resource` VALUES (1, 0, 1, 'dashboard', 'dashboard', '控制台', 'dashboard', '', '', 0, 1, '2020-08-26 15:20:32', '2021-06-02 11:15:03');
INSERT INTO `admin_resource` VALUES (2, 0, 1, 'admin', 'admin', '权限管理', 'team', '', '', 0, 1, '2020-08-26 15:20:32', '2021-05-31 15:51:47');
INSERT INTO `admin_resource` VALUES (3, 2, 1, 'admin/admin', '', '管理员管理', 'team', '', '', 0, 1, '2020-08-26 15:20:32', '2020-10-20 17:05:25');
INSERT INTO `admin_resource` VALUES (4, 3, 2, 'admin/admin/index', '', '查看', '', '', '', 0, 1, '2020-08-26 15:20:32', '2020-10-20 17:08:02');
INSERT INTO `admin_resource` VALUES (5, 3, 2, 'admin/admin/detail', '', '详情', '', '', '', 0, 1, '2020-08-26 15:20:32', '2020-10-20 14:40:19');
INSERT INTO `admin_resource` VALUES (6, 3, 2, 'admin/admin/add', '', '添加', '', '', '', 0, 1, '2020-08-26 15:20:32', '2020-10-20 14:40:30');
INSERT INTO `admin_resource` VALUES (7, 3, 2, 'admin/admin/edit', '', '编辑', '', '', '', 0, 1, '2020-08-26 15:20:32', '2020-10-20 14:40:40');
INSERT INTO `admin_resource` VALUES (8, 3, 2, 'admin/admin/del', '', '删除', '', '', '', 0, 1, '2020-08-26 15:20:32', '2020-10-20 14:44:57');
INSERT INTO `admin_resource` VALUES (9, 2, 1, 'admin/role', 'admin.role', '角色组', 'cluster', '', '', 0, 1, '2020-08-26 15:20:32', '2021-05-31 17:12:48');
INSERT INTO `admin_resource` VALUES (10, 9, 2, 'admin/role/index', 'admin.role.index', '查看', '', '', '', 0, 1, '2020-08-26 15:20:32', '2021-05-31 17:13:56');
INSERT INTO `admin_resource` VALUES (11, 9, 2, 'admin/role/detail', 'admin.role.detail', '详情', '', '', '', 0, 1, '2020-08-26 15:20:32', '2021-05-31 17:14:18');
INSERT INTO `admin_resource` VALUES (12, 9, 2, 'admin/role/add', 'admin.role.add', '添加', '', '', '', 0, 1, '2020-08-26 15:20:32', '2021-05-31 17:14:37');
INSERT INTO `admin_resource` VALUES (13, 9, 2, 'admin/role/edit', 'admin.role.edit', '编辑', '', '', '', 0, 1, '2020-08-26 15:20:32', '2021-05-31 17:14:52');
INSERT INTO `admin_resource` VALUES (14, 9, 2, 'admin/role/del', 'admin.role.del', '删除', '', '', '', 0, 1, '2020-08-26 15:20:32', '2021-05-31 17:15:04');
INSERT INTO `admin_resource` VALUES (15, 2, 1, 'admin/resource', '', '菜单规则', 'menu', '', '', 0, 1, '2020-08-26 15:20:32', '2020-10-20 17:20:03');
INSERT INTO `admin_resource` VALUES (16, 15, 2, 'admin/resource/index', '', '查看', '', '', '', 0, 1, '2020-08-26 15:20:32', '2020-10-20 14:45:46');
INSERT INTO `admin_resource` VALUES (17, 15, 2, 'admin/resource/detail', '', '详情', '', '', '', 0, 1, '2020-08-26 15:20:32', '2020-10-20 14:45:35');
INSERT INTO `admin_resource` VALUES (18, 15, 2, 'admin/resource/add', '', '添加', '', '', '', 0, 1, '2020-08-26 15:20:32', '2020-10-20 14:45:24');
INSERT INTO `admin_resource` VALUES (19, 15, 2, 'admin/resource/edit', '', '编辑', '', '', '', 0, 1, '2020-08-26 15:20:32', '2020-10-20 14:45:14');
INSERT INTO `admin_resource` VALUES (20, 15, 2, 'admin/resource/del', '', '删除', '', '', '', 0, 1, '2020-08-26 15:20:32', '2020-10-20 14:43:47');
INSERT INTO `admin_resource` VALUES (21, 2, 1, 'admin/log', '', '管理员日志', 'unordered-list', '', '', 0, 1, '2020-08-26 15:20:32', '2020-10-20 17:20:36');
INSERT INTO `admin_resource` VALUES (22, 21, 2, 'admin/log/index', '', '查看', '', '', '', 0, 1, '2020-08-26 15:20:32', '2020-10-20 14:43:13');
INSERT INTO `admin_resource` VALUES (23, 21, 2, 'admin/log/detail', '', '详情', '', '', '', 0, 1, '2020-08-26 15:20:32', '2020-10-20 14:43:21');
COMMIT;

-- ----------------------------
-- Table structure for admin_role
-- ----------------------------
DROP TABLE IF EXISTS `admin_role`;
CREATE TABLE `admin_role` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `pid` int unsigned NOT NULL DEFAULT '0' COMMENT '父组ID',
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '组名',
  `status` tinyint unsigned NOT NULL DEFAULT '1' COMMENT '状态:0=隐藏,1=显示',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4158 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='角色表';

-- ----------------------------
-- Records of admin_role
-- ----------------------------
BEGIN;
INSERT INTO `admin_role` VALUES (1, 0, '超级管理员', 1, '2020-08-25 08:18:44', '2020-08-12 17:40:36');
INSERT INTO `admin_role` VALUES (4154, 1, '一级管理员', 1, '2021-06-15 17:08:47', '2021-06-15 17:08:47');
INSERT INTO `admin_role` VALUES (4155, 4154, '二级管理员', 1, '2021-06-15 17:09:03', '2021-06-15 17:09:03');
INSERT INTO `admin_role` VALUES (4156, 4155, '三级管理员', 1, '2021-06-15 17:09:25', '2021-06-15 17:09:25');
INSERT INTO `admin_role` VALUES (4157, 4156, '四级管理员', 1, '2021-06-15 17:09:49', '2021-06-15 17:09:49');
COMMIT;

-- ----------------------------
-- Table structure for admin_role_access
-- ----------------------------
DROP TABLE IF EXISTS `admin_role_access`;
CREATE TABLE `admin_role_access` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `admin_id` int unsigned NOT NULL DEFAULT '0' COMMENT '管理员ID',
  `role_id` int unsigned NOT NULL DEFAULT '0' COMMENT '角色ID',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `admin_id` (`admin_id`,`role_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='用户角色关系表';

-- ----------------------------
-- Records of admin_role_access
-- ----------------------------
BEGIN;
INSERT INTO `admin_role_access` VALUES (1, 1, 1, '2020-08-20 10:26:24', '2020-08-20 10:26:24');
INSERT INTO `admin_role_access` VALUES (38, 22, 4154, '2021-06-15 17:10:45', '2021-06-15 17:10:45');
INSERT INTO `admin_role_access` VALUES (39, 22, 4155, '2021-06-15 17:14:31', '2021-06-15 17:14:31');
INSERT INTO `admin_role_access` VALUES (40, 22, 4156, '2021-06-15 17:14:31', '2021-06-15 17:14:31');
INSERT INTO `admin_role_access` VALUES (41, 22, 4157, '2021-06-15 17:14:31', '2021-06-15 17:14:31');
COMMIT;

-- ----------------------------
-- Table structure for admin_role_resource_access
-- ----------------------------
DROP TABLE IF EXISTS `admin_role_resource_access`;
CREATE TABLE `admin_role_resource_access` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `role_id` int unsigned NOT NULL DEFAULT '0' COMMENT '角色ID',
  `resource_id` int unsigned NOT NULL DEFAULT '0' COMMENT '资源ID:0=超级管理员',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `group_id` (`role_id`,`resource_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=346 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='角色资源关系表';

-- ----------------------------
-- Records of admin_role_resource_access
-- ----------------------------
BEGIN;
INSERT INTO `admin_role_resource_access` VALUES (1, 1, 0, '2020-08-26 10:56:29', '2020-08-26 10:56:29');
INSERT INTO `admin_role_resource_access` VALUES (300, 4154, 2, '2021-06-15 17:08:47', '2021-06-15 17:08:47');
INSERT INTO `admin_role_resource_access` VALUES (301, 4154, 3, '2021-06-15 17:08:47', '2021-06-15 17:08:47');
INSERT INTO `admin_role_resource_access` VALUES (302, 4154, 4, '2021-06-15 17:08:47', '2021-06-15 17:08:47');
INSERT INTO `admin_role_resource_access` VALUES (303, 4154, 5, '2021-06-15 17:08:47', '2021-06-15 17:08:47');
INSERT INTO `admin_role_resource_access` VALUES (304, 4154, 6, '2021-06-15 17:08:47', '2021-06-15 17:08:47');
INSERT INTO `admin_role_resource_access` VALUES (305, 4154, 7, '2021-06-15 17:08:47', '2021-06-15 17:08:47');
INSERT INTO `admin_role_resource_access` VALUES (306, 4154, 8, '2021-06-15 17:08:47', '2021-06-15 17:08:47');
INSERT INTO `admin_role_resource_access` VALUES (307, 4154, 9, '2021-06-15 17:08:47', '2021-06-15 17:08:47');
INSERT INTO `admin_role_resource_access` VALUES (308, 4154, 10, '2021-06-15 17:08:47', '2021-06-15 17:08:47');
INSERT INTO `admin_role_resource_access` VALUES (309, 4154, 11, '2021-06-15 17:08:47', '2021-06-15 17:08:47');
INSERT INTO `admin_role_resource_access` VALUES (310, 4154, 12, '2021-06-15 17:08:47', '2021-06-15 17:08:47');
INSERT INTO `admin_role_resource_access` VALUES (311, 4154, 13, '2021-06-15 17:08:47', '2021-06-15 17:08:47');
INSERT INTO `admin_role_resource_access` VALUES (312, 4154, 14, '2021-06-15 17:08:47', '2021-06-15 17:08:47');
INSERT INTO `admin_role_resource_access` VALUES (313, 4154, 15, '2021-06-15 17:08:47', '2021-06-15 17:08:47');
INSERT INTO `admin_role_resource_access` VALUES (314, 4154, 16, '2021-06-15 17:08:47', '2021-06-15 17:08:47');
INSERT INTO `admin_role_resource_access` VALUES (315, 4154, 17, '2021-06-15 17:08:47', '2021-06-15 17:08:47');
INSERT INTO `admin_role_resource_access` VALUES (316, 4154, 18, '2021-06-15 17:08:47', '2021-06-15 17:08:47');
INSERT INTO `admin_role_resource_access` VALUES (317, 4154, 19, '2021-06-15 17:08:47', '2021-06-15 17:08:47');
INSERT INTO `admin_role_resource_access` VALUES (318, 4154, 20, '2021-06-15 17:08:47', '2021-06-15 17:08:47');
INSERT INTO `admin_role_resource_access` VALUES (319, 4154, 21, '2021-06-15 17:08:47', '2021-06-15 17:08:47');
INSERT INTO `admin_role_resource_access` VALUES (320, 4154, 22, '2021-06-15 17:08:47', '2021-06-15 17:08:47');
INSERT INTO `admin_role_resource_access` VALUES (321, 4154, 23, '2021-06-15 17:08:47', '2021-06-15 17:08:47');
INSERT INTO `admin_role_resource_access` VALUES (322, 4155, 2, '2021-06-15 17:09:03', '2021-06-15 17:09:03');
INSERT INTO `admin_role_resource_access` VALUES (323, 4155, 3, '2021-06-15 17:09:03', '2021-06-15 17:09:03');
INSERT INTO `admin_role_resource_access` VALUES (324, 4155, 4, '2021-06-15 17:09:03', '2021-06-15 17:09:03');
INSERT INTO `admin_role_resource_access` VALUES (325, 4155, 5, '2021-06-15 17:09:03', '2021-06-15 17:09:03');
INSERT INTO `admin_role_resource_access` VALUES (326, 4155, 6, '2021-06-15 17:09:03', '2021-06-15 17:09:03');
INSERT INTO `admin_role_resource_access` VALUES (327, 4155, 7, '2021-06-15 17:09:03', '2021-06-15 17:09:03');
INSERT INTO `admin_role_resource_access` VALUES (328, 4155, 8, '2021-06-15 17:09:03', '2021-06-15 17:09:03');
INSERT INTO `admin_role_resource_access` VALUES (329, 4155, 9, '2021-06-15 17:09:03', '2021-06-15 17:09:03');
INSERT INTO `admin_role_resource_access` VALUES (330, 4155, 10, '2021-06-15 17:09:03', '2021-06-15 17:09:03');
INSERT INTO `admin_role_resource_access` VALUES (331, 4155, 11, '2021-06-15 17:09:03', '2021-06-15 17:09:03');
INSERT INTO `admin_role_resource_access` VALUES (332, 4155, 12, '2021-06-15 17:09:03', '2021-06-15 17:09:03');
INSERT INTO `admin_role_resource_access` VALUES (333, 4155, 13, '2021-06-15 17:09:03', '2021-06-15 17:09:03');
INSERT INTO `admin_role_resource_access` VALUES (334, 4155, 14, '2021-06-15 17:09:03', '2021-06-15 17:09:03');
INSERT INTO `admin_role_resource_access` VALUES (335, 4156, 2, '2021-06-15 17:09:25', '2021-06-15 17:09:25');
INSERT INTO `admin_role_resource_access` VALUES (336, 4156, 3, '2021-06-15 17:09:25', '2021-06-15 17:09:25');
INSERT INTO `admin_role_resource_access` VALUES (337, 4156, 4, '2021-06-15 17:09:25', '2021-06-15 17:09:25');
INSERT INTO `admin_role_resource_access` VALUES (338, 4156, 5, '2021-06-15 17:09:25', '2021-06-15 17:09:25');
INSERT INTO `admin_role_resource_access` VALUES (339, 4156, 6, '2021-06-15 17:09:25', '2021-06-15 17:09:25');
INSERT INTO `admin_role_resource_access` VALUES (340, 4156, 7, '2021-06-15 17:09:25', '2021-06-15 17:09:25');
INSERT INTO `admin_role_resource_access` VALUES (341, 4156, 8, '2021-06-15 17:09:25', '2021-06-15 17:09:25');
INSERT INTO `admin_role_resource_access` VALUES (342, 4157, 2, '2021-06-15 17:09:49', '2021-06-15 17:09:49');
INSERT INTO `admin_role_resource_access` VALUES (343, 4157, 3, '2021-06-15 17:09:49', '2021-06-15 17:09:49');
INSERT INTO `admin_role_resource_access` VALUES (344, 4157, 4, '2021-06-15 17:09:49', '2021-06-15 17:09:49');
INSERT INTO `admin_role_resource_access` VALUES (345, 4157, 5, '2021-06-15 17:09:49', '2021-06-15 17:09:49');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
